{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Select County","PCR Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Select County","index":0,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Select District","Select County","File Location"]
[null,null,"C:\\Users\\sdeer\\Desktop\\"]

{"sheet":"PCR Data","index":1,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["LookUp","NLF_ID","PCR_NBR","PCR_PROJECTION_YR","LOGPOINT_COUNTY_NBR","LATITUDE_NBR","LONGITUDE_NBR","PRIORITY_SYS_CD","End Log","E Lat","E Long","Color","No. of Segments"]
[null,"STUSIR00077**C",94,2014,0,40.219625000000001,-81.552401000000003,"P",{"$f":"IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[NLF_ID]]=B3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LOGPOINT_COUNTY_NBR]]+0.01=E3),E3,IF(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LOGPOINT_COUNTY_NBR]],I3))","v":0},{"$f":"IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[NLF_ID]]=B3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LOGPOINT_COUNTY_NBR]]+0.01=E3),F3,IF(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LATITUDE_NBR]],J3))","v":40.219625000000001},{"$f":"IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[NLF_ID]]=B3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LOGPOINT_COUNTY_NBR]]+0.01=E3),G3,IF(Table_Query_from_SYBIQ01PRD15[[#This Row],[No. of Segments]]<>M3,Table_Query_from_SYBIQ01PRD15[[#This Row],[LONGITUDE_NBR]],K3))","v":-81.552401000000003},{"$f":"IF(Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]>84,1,IF(Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]>74,2,IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[PRIORITY_SYS_CD]]=\"P\",Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]>64),3,IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[PRIORITY_SYS_CD]]=\"G\",Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]>59),3,IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[PRIORITY_SYS_CD]]=\"U\",Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]>54),3,4)))))","v":1},{"$f":"IF(ROW()=2,1,IF(AND(Table_Query_from_SYBIQ01PRD15[[#This Row],[PRIORITY_SYS_CD]]=H1,Table_Query_from_SYBIQ01PRD15[[#This Row],[LOGPOINT_COUNTY_NBR]]=(E1+0.01),Table_Query_from_SYBIQ01PRD15[[#This Row],[NLF_ID]]=B1,Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_PROJECTION_YR]]=D1,Table_Query_from_SYBIQ01PRD15[[#This Row],[PCR_NBR]]=C1),M1,M1+1))","v":1}]